package cn.gson.crm.model.pojo;

import java.io.Serializable;
import javax.persistence.*;
import java.math.BigDecimal;
import java.util.Date;


/**
 * The persistent class for the SENDGOODSDETAILS database table.
 * 
 */
@Entity
@Table(name="SENDGOODSDETAILS")
@NamedQuery(name="Sendgoodsdetail.findAll", query="SELECT s FROM Sendgoodsdetail s")
public class Sendgoodsdetail implements Serializable {
	private static final long serialVersionUID = 1L;

	@Id
	@SequenceGenerator(initialValue=1,allocationSize=1,name="SENDGOODSDETAILS_SGDID_GENERATOR", sequenceName="SEQ_44")
	@GeneratedValue(strategy=GenerationType.SEQUENCE, generator="SENDGOODSDETAILS_SGDID_GENERATOR")
	@Column(name="SGD_ID")
	private long sgdId;

	@Column(name="SGD_CO_ID")
	private BigDecimal sgdCoId;

	@Column(name="SGD_CO_THEME")
	private String sgdCoTheme;

	@Column(name="SGD_COST")
	private BigDecimal sgdCost;

	@Column(name="SGD_CUS_ID")
	private BigDecimal sgdCusId;

	@Column(name="SGD_CUS_NAME")
	private String sgdCusName;

	@Column(name="SGD_NUMBER")
	private BigDecimal sgdNumber;

	@Column(name="SGD_PRO_ID")
	private BigDecimal sgdProId;

	@Column(name="SGD_PRO_NAME")
	private String sgdProName;

	@Column(name="SGD_PRO_PRICE")
	private BigDecimal sgdProPrice;

	@Column(name="SGD_REMARKS")
	private String sgdRemarks;

	@Temporal(TemporalType.DATE)
	@Column(name="SGD_TIME")
	private Date sgdTime;

	//bi-directional many-to-one association to ConstactOrder
	@ManyToOne
	@JoinColumn(name="CO_ID")
	private ConstactOrder constactOrder;

	//bi-directional many-to-one association to Customerinfo
	@ManyToOne
	@JoinColumn(name="CUST_ID")
	private Customerinfo customerinfo;

	public Sendgoodsdetail() {
	}

	public long getSgdId() {
		return this.sgdId;
	}

	public void setSgdId(long sgdId) {
		this.sgdId = sgdId;
	}

	public BigDecimal getSgdCoId() {
		return this.sgdCoId;
	}

	public void setSgdCoId(BigDecimal sgdCoId) {
		this.sgdCoId = sgdCoId;
	}

	public String getSgdCoTheme() {
		return this.sgdCoTheme;
	}

	public void setSgdCoTheme(String sgdCoTheme) {
		this.sgdCoTheme = sgdCoTheme;
	}

	public BigDecimal getSgdCost() {
		return this.sgdCost;
	}

	public void setSgdCost(BigDecimal sgdCost) {
		this.sgdCost = sgdCost;
	}

	public BigDecimal getSgdCusId() {
		return this.sgdCusId;
	}

	public void setSgdCusId(BigDecimal sgdCusId) {
		this.sgdCusId = sgdCusId;
	}

	public String getSgdCusName() {
		return this.sgdCusName;
	}

	public void setSgdCusName(String sgdCusName) {
		this.sgdCusName = sgdCusName;
	}

	public BigDecimal getSgdNumber() {
		return this.sgdNumber;
	}

	public void setSgdNumber(BigDecimal sgdNumber) {
		this.sgdNumber = sgdNumber;
	}

	public BigDecimal getSgdProId() {
		return this.sgdProId;
	}

	public void setSgdProId(BigDecimal sgdProId) {
		this.sgdProId = sgdProId;
	}

	public String getSgdProName() {
		return this.sgdProName;
	}

	public void setSgdProName(String sgdProName) {
		this.sgdProName = sgdProName;
	}

	public BigDecimal getSgdProPrice() {
		return this.sgdProPrice;
	}

	public void setSgdProPrice(BigDecimal sgdProPrice) {
		this.sgdProPrice = sgdProPrice;
	}

	public String getSgdRemarks() {
		return this.sgdRemarks;
	}

	public void setSgdRemarks(String sgdRemarks) {
		this.sgdRemarks = sgdRemarks;
	}

	public Date getSgdTime() {
		return this.sgdTime;
	}

	public void setSgdTime(Date sgdTime) {
		this.sgdTime = sgdTime;
	}

	public ConstactOrder getConstactOrder() {
		return this.constactOrder;
	}

	public void setConstactOrder(ConstactOrder constactOrder) {
		this.constactOrder = constactOrder;
	}

	public Customerinfo getCustomerinfo() {
		return this.customerinfo;
	}

	public void setCustomerinfo(Customerinfo customerinfo) {
		this.customerinfo = customerinfo;
	}

}